/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package br.ufjf.posjava.cm.controller.action.consulta;

import br.ufjf.posjava.cm.model.DAO.ConsultaDAO;
import br.ufjf.posjava.cm.model.DAO.PacienteDAO;
import br.ufjf.posjava.cm.model.DAO.ProfissionalDAO;
import br.ufjf.posjava.cm.util.TrataDatas;
import java.io.IOException;
import java.sql.SQLException;
import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 *
 * @author Filipe
 */
public class PesquisaConsultaAction extends HttpServlet {

    /**
     * Processes requests for both HTTP
     * <code>GET</code> and
     * <code>POST</code> methods.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");

        String nomePaciente = request.getParameter("cpNome");
        String data = request.getParameter("cpData");
        String btn = request.getParameter("btn");
        Integer idProfissional = Integer.parseInt(request.getParameter("idProfissional"));

        RequestDispatcher rd = request.getRequestDispatcher("index.jsp");
        request.setAttribute("pag", "listaConsulta.jsp");

        if (btn.equalsIgnoreCase("Pesquisar por nome")) {
            if (((nomePaciente == null) || (nomePaciente.equalsIgnoreCase("")))) {
                try {
                    request.setAttribute("ListaConsulta", new ConsultaDAO().buscarTodasAgendasAgendadasPorDentista(idProfissional));
                    request.setAttribute("ListaProfissional", new ProfissionalDAO().buscarTodos());
                    request.setAttribute("ListaPaciente", new PacienteDAO().buscarTodos());
                } catch (ClassNotFoundException ex) {
                    request.setAttribute("msg", ex.getMessage());
                    request.setAttribute("pag", "erro.jsp");
                } catch (SQLException ex) {
                    request.setAttribute("msg", ex.getMessage());
                    request.setAttribute("pag", "erro.jsp");
                }

            } else {
                try {
                    request.setAttribute("ListaConsulta", new ConsultaDAO().buscarConsultaPeloNome(idProfissional, nomePaciente));
                    request.setAttribute("ListaProfissional", new ProfissionalDAO().buscarTodos());
                    request.setAttribute("ListaPaciente", new PacienteDAO().buscarTodos());
                } catch (ClassNotFoundException ex) {
                    request.setAttribute("msg", ex.getMessage());
                    request.setAttribute("pag", "erro.jsp");
                } catch (SQLException ex) {
                    request.setAttribute("msg", ex.getMessage());
                    request.setAttribute("pag", "erro.jsp");
                }

            }
        } else {
            if (((data == null) || (data.equalsIgnoreCase("")))) {
                try {
                    request.setAttribute("ListaConsulta", new ConsultaDAO().buscarTodasAgendasAgendadasPorDentista(idProfissional));
                    request.setAttribute("ListaProfissional", new ProfissionalDAO().buscarTodos());
                    request.setAttribute("ListaPaciente", new PacienteDAO().buscarTodos());
                } catch (ClassNotFoundException ex) {
                    request.setAttribute("msg", ex.getMessage());
                    request.setAttribute("pag", "erro.jsp");
                } catch (SQLException ex) {
                    request.setAttribute("msg", ex.getMessage());
                    request.setAttribute("pag", "erro.jsp");
                }

            } else {
                try {
                    Date dataForm;
                    DateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy"); //não passo o horário
                    long timestamp = dateFormat.parse(data).getTime();
                    dataForm = new Date(timestamp);

                    request.setAttribute("ListaConsulta", new ConsultaDAO().buscarConsultaPelaData(idProfissional, dataForm));
                    request.setAttribute("ListaProfissional", new ProfissionalDAO().buscarTodos());
                    request.setAttribute("ListaPaciente", new PacienteDAO().buscarTodos());
                } catch (ParseException ex) {
                    request.setAttribute("msg", ex.getMessage());
                    request.setAttribute("pag", "erro.jsp");
                } catch (ClassNotFoundException ex) {
                    request.setAttribute("msg", ex.getMessage());
                    request.setAttribute("pag", "erro.jsp");
                } catch (SQLException ex) {
                    request.setAttribute("msg", ex.getMessage());
                    request.setAttribute("pag", "erro.jsp");
                }
            }

        }

        rd.forward(request, response);

    }

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /**
     * Handles the HTTP
     * <code>GET</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Handles the HTTP
     * <code>POST</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Returns a short description of the servlet.
     *
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>
}
